Select Range
AutomatR.Excel.Activities.SelectRange
The "Select Range" activity in AutomatR is part of the Excel activities package, designed to facilitate the selection of a specified range within an Excel spreadsheet. This activity is crucial for isolating specific data or cells for further actions in the automation process.
NOTE: This activity can only be used in Excel Root activity.
Properties
| Name | Description |
|---|---|
| Input | |
| Range | Enter the range to be selected. This should be in the format of Excel range, such as "A1:B5". String variables containing the desired range. |
| Misc | |
| Display Name | The display name of the activity. A display name is automatically generated when you indicate a target. |
| Optional | |
| Delay | Enter the wait time in seconds (Example: 5 seconds i.e., 5) to start the activity. Integer variables containing the delay duration. |
How to use:
- Drag and drop the "Select Range" activity onto the workflow.
- Configure the properties by specifying the range to be selected.
- Optionally, configure the delay.
- Execute the workflow to select the specified range within the Excel spreadsheet.
Important:
- Ensure that the Excel workbook and sheet are open and accessible.
- The specified range should be in a valid Excel range format (e.g., "A1:B5").
- Incorrect range formats may result in an "Invalid given Range" error.